Skip to main content
This forum is closed to new posts and responses. The content has been migrated to the Digital Solutions Community. Please join us there for new content as well as this content. For customer support, please visit the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)
Previous Next

try backend RDMS + Notes....

Notes was made more for collaboration than a monster RDMS.

Two million is just a lot, and I would bet any RDMS system would run circles around Notes if all you are doing is query's or @dblookup-like calls.

(I have create MS Access databases that takes user's data with simple joins and where clauses to create reports in 10 seconds where the same data in MS Excel took over 2 hours.)

I would try exporting the data to a backend RDMS like DB2, Oracle, or SQL Server. Index it accordingly and properly for performance. If you can keep it on the same box, it will tax your CPU but save you networking calls. Then, use LEI if performance is important to connect to the information in Lotus Notes. (note, LEI can be much faster than ODBC if the LEI is using the native drivers.)

-Kyle Huang


Feedback response number WEBB8MATNM created by ~John Reniskiikle on 10/03/2011

Lotus Approach to Notes - 2 million... (~Nita Quetboosi... 30.Sep.11)
. . try backend RDMS + Notes.... (~John Reniskiik... 3.Oct.11)
. . . . Thanks Kyle (~Nita Quetboosi... 4.Oct.11)
. . . . . . also, remember the "cache" (~John Reniskiik... 4.Oct.11)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS